-- auto Generated on 2024-07-24
-- DROP TABLE IF EXISTS quality_data;
CREATE TABLE quality_data(
                             times NVARCHAR (50) NOT NULL,
                             lng_work_load_no NVARCHAR (50) NOT NULL IDENTITY(1,1) PRIMARY KEY,
                             str_department_name NVARCHAR (50) NOT NULL,
                             str_goods_name NVARCHAR (50) NOT NULL,
                             material NVARCHAR (50) NOT NULL,
                             cus_material NVARCHAR (50) NOT NULL,
                             type_of_machine NVARCHAR (50) NOT NULL,
                             invest DECIMAL (13,4) NOT NULL,
                             plan_sum DECIMAL (13,4) NOT NULL,
                             pending DECIMAL (13,4) NOT NULL,
                             pending_cumulative DECIMAL (13,4) NOT NULL,
                             non_defective DECIMAL (13,4) NOT NULL,
                             defective_products DECIMAL (13,4) NOT NULL,
                             poor_distribution NVARCHAR (50) NOT NULL,
                             percentage NVARCHAR (50) NOT NULL,
                             type_name NVARCHAR (50) NOT NULL
)
    go exec sp_addextendedproperty 'MS_Description', 'times', 'SCHEMA', 'dbo', 'TABLE', 'quality_data', 'COLUMN', 'times'

go exec sp_addextendedproperty 'MS_Description', '工单号', 'SCHEMA', 'dbo', 'TABLE', 'quality_data', 'COLUMN', 'lng_work_load_no'

go exec sp_addextendedproperty 'MS_Description', '制程', 'SCHEMA', 'dbo', 'TABLE', 'quality_data', 'COLUMN', 'str_department_name'

go exec sp_addextendedproperty 'MS_Description', '品名', 'SCHEMA', 'dbo', 'TABLE', 'quality_data', 'COLUMN', 'str_goods_name'

go exec sp_addextendedproperty 'MS_Description', '东矩', 'SCHEMA', 'dbo', 'TABLE', 'quality_data', 'COLUMN', 'material'

go exec sp_addextendedproperty 'MS_Description', '纬创料号', 'SCHEMA', 'dbo', 'TABLE', 'quality_data', 'COLUMN', 'cus_material'

go exec sp_addextendedproperty 'MS_Description', '机种', 'SCHEMA', 'dbo', 'TABLE', 'quality_data', 'COLUMN', 'type_of_machine'

go exec sp_addextendedproperty 'MS_Description', '投入数', 'SCHEMA', 'dbo', 'TABLE', 'quality_data', 'COLUMN', 'invest'

go exec sp_addextendedproperty 'MS_Description', 'planSum', 'SCHEMA', 'dbo', 'TABLE', 'quality_data', 'COLUMN', 'plan_sum'

go exec sp_addextendedproperty 'MS_Description', '待处理数', 'SCHEMA', 'dbo', 'TABLE', 'quality_data', 'COLUMN', 'pending'

go exec sp_addextendedproperty 'MS_Description', '累计待处理数', 'SCHEMA', 'dbo', 'TABLE', 'quality_data', 'COLUMN', 'pending_cumulative'

go exec sp_addextendedproperty 'MS_Description', '良品数', 'SCHEMA', 'dbo', 'TABLE', 'quality_data', 'COLUMN', 'non_defective'

go exec sp_addextendedproperty 'MS_Description', '不良品数', 'SCHEMA', 'dbo', 'TABLE', 'quality_data', 'COLUMN', 'defective_products'

go exec sp_addextendedproperty 'MS_Description', '不良分布', 'SCHEMA', 'dbo', 'TABLE', 'quality_data', 'COLUMN', 'poor_distribution'

go exec sp_addextendedproperty 'MS_Description', '良率', 'SCHEMA', 'dbo', 'TABLE', 'quality_data', 'COLUMN', 'percentage'

go exec sp_addextendedproperty 'MS_Description', 'typeName', 'SCHEMA', 'dbo', 'TABLE', 'quality_data', 'COLUMN', 'type_name'

